Solved: Connect IT get part of string - Micro Focus Community - 585670

526 views

Hi,

My data is abcdefgh. I want to take 3th(c) and 4th(d) character.

How can I extract string? Which function should I use in Connect-IT?

Thanks

1 Solution

Accepted Solutions

There are a few ways so check the programmer's reference pdf guide (under Docs folder).

3rd & 4th - Right(Left("abcdefgh",4),2)

3rd - Right(Left("abcdefgh",3),1)

4th - Right(Left("abcdefgh",4),1)

3rd & 4th - Mid("abcdefgh",3,2)

3rd - Mid("abcdefgh",3,1)

4th - Mid("abcdefgh",4,1)

View solution in original post

1 Reply

There are a few ways so check the programmer's reference pdf guide (under Docs folder).

3rd & 4th - Right(Left("abcdefgh",4),2)

3rd - Right(Left("abcdefgh",3),1)

4th - Right(Left("abcdefgh",4),1)

3rd & 4th - Mid("abcdefgh",3,2)

3rd - Mid("abcdefgh",3,1)

4th - Mid("abcdefgh",4,1)

View solution in original post

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the . Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.