remove string Dynamically

[marpadga18]

Hi All

I am trying to get the data between the string dynamically which is '~'. Any ideas would be appreciated.

Source
0000000002
000000000
~0000000009~1001~
~VENDOR~0000000138~1001~
~VENDOR~0020009816~2001~
~0020009816~2100~

Target required
0000000002
000000000
0000000009
0000000138
0020009816
0020009816

Thanks for the help

[chulett]

Start by looking into the Field() function but... clarify your rules / requirements for us.

[roy]

Hi,
As craig said your example seems to have a changing algorithym

0000000002
000000000
~0000000009~1001~
~VENDOR~0000000138~1001~
~VENDOR~0020009816~2001~
~0020009816~2100~

in the above example you supplied there are several different logics for extracting the data
rows 1+2 first and only field
rows 3 & 6 2nd field using the ~ delimiter
rows 4+5 3rd field using the ~ delimiter

so the question is:
what is the actual logic for extracting the numbers?

[ray.wurlod]

If you use a BASIC Transformer stage the following expression will work.

Code: Select all

MatchField(InLink.TheString, "~0N0N0X", 2)

This returns the first wholly numeric string in the original string.
The tilde in the pattern is unrelated to tildes in the source string. The first part of the pattern ("~0N") is matched by any number of non-numeric characters, the second part of the pattern ("0N") is matched by any number of entirely numeric characters, and the third part of the pattern ("0X") is matched by anything.