Standarizing a String by clearing a portion of it

[Woodson_Louis]

I would like to change this AAAA / BBBB /CCCC / DDDD pattern to this: BBBB / CCCC / DDDD

for exemple an adress like: Daniel Boone / 8888 Riverview Dr / Calgary / CA
to 8888 Riverview Dr / Calgary / CA

Any help ? Thanks in advance

[postwick (Paul)]

Use Split on /

[fernando_zuluaga]

Hi @Woodson_Louis

How about the following?

String.Join("/", strInput.Split("/"c).Skip(1).Select(Function(e) e.Trim()))

BTW: if you want with the spaces just remove the .Trim() like this

String.Join("/", strInput.Split("/"c).Skip(1).Select(Function(e) e))

Regards!

[Steven_McKeering]

@Woodson_Louis

Daniel Boone / 8888 Riverview Dr / Calgary / CA

Hello

You could use a ‘Regex.Replace’. Match the starting text you need then replace with nothing (“”).

Insert the following into an assign activity.

Left Assign:
str_Result

Right Assign:
System.Text.RegularExpressions.Regex.Replace(yourStr, “^[\/]+\/\s+”, “”)

Preview the link here:

.NET Regex Tester - Regex Storm

Cheers

Steve

[Woodson_Louis]

Thank you guys for the help @fernando_zuluaga , @Steven_McKeering and @postwick

[Steven_McKeering]

Hey @Woodson_Louis

Always happy to help

Cheers

Steve