String Manipulation

[Krish]

Hi,

I need a help in converting string in following way.

1_Rec_Type to be converted to 1:Rec_type

2_Rec_Len to be converted to 2:Rec_Len

i.e first occurrence of _ to be replaced with :

thanks,

Krish

[patrick_digan · Accepted solution]

@Krish Have a look at the function ReplaceFirst. Here is the help doc on it:

ReplaceFirst(Str, Target, Replacement)

Returns the string (Str) after replacing the first occurrence of the string (Target) with the string (Replacement).

Example

ReplaceFirst("abcdefb", "b", "_") returns "a_cdefb"

[daniellefzimmerman]

thank you! I did not know this formula existed. you saved me hours of headache.