107985_en-US

liliconcom

Extracting substring and converting to column

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

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);
);