topic Re: Extracting substring and converting to column in Discussions

Extracting substring and converting to column

ENTHU — Thu, 24 Jan 2019 21:08:55 GMT

Hi,

Need some help with proceesing a long string.

I have a table with several columns;one column has a long string as follows-

Entity	Substring
A	RWYT\|ZZRZQ_pp29_Nxy13_7\|54.58\|ZZRZQ_pp29_Nxy13_3\|51.72\|ZZRZQ_pp29_Nxy13_5\|54.31

I need to remove first four characters "RWYT" and expected output is as follows:

Entity	Substring	ZZRZQ_pp29_Nxy13_7	ZZRZQ_pp29_Nxy13_3	ZZRZQ_pp29_Nxy13_5
A	RWYT\|ZZRZQ_pp29_Nxy13_7\|54.58\|ZZRZQ_pp29_Nxy13_3\|51.72\|ZZRZQ_pp29_Nxy13_5\|54.31	54.58	51.72	54.31

Re: Extracting substring and converting to column

txnelson — Thu, 24 Jan 2019 21:21:15 GMT

The character functions are all very nicely organized in the Scripting Index. When you need to manipulate a string, you can very easily go through the various functions and the examples shown, to determine which one to use.......You need to spend the time to do this!

For what you are trying to do....

Names Default to Here( 1 );
dt = Current Data Table();

For Each Row(
     :Substring = Substr(:Substring, 5);
);