Regex

BRRLL99

input:

data

456 //SG201AB TGHFG01

ABCF //345-ASDTG

001 //123123

ABC//5690AB 90111

RRR //5089--ASD JKLP

output should should start from // till the next space

i have tried using this formula (\/\/\w+?)(?=\s), it is not giving expected results

Expected Output

//SG201AB

//345-ASDTG

//123123

//5690AB

//5089--ASD

#regex

Regex

Accepted answers

flying008

Hi, @BRRLL99

Please repalce only $1 by (\/\/[[:alnum:]\-]+?)(?=\s|$)

or parse by above:

录制_2024_05_16_11_16_51_95.gif

flying008

Hi, @BRRLL99

FYI.

use the formula :

REGEX_Replace([data], '^(\S+?)\s+(\/\/\s?[[:alnum:]\-]+?)(?=\s|$).*', IIF([D_1] = 'SAR', '$1 $2', '$2'))

录制_2024_05_20_13_52_38_572.gif

All comments

flying008

Hi, @BRRLL99

Please repalce only $1 by (\/\/[[:alnum:]\-]+?)(?=\s|$)

or parse by above:

录制_2024_05_16_11_16_51_95.gif

BRRLL99

D_1	data
AA	456 //SG201AB TGHFG01
AA	ABCF //345-ASDTG
BB	001 //123123
SAR	ABC //5690AB 90111
SAR	RRR //5089--ASD JKLP

whenever there is SAR, it should be

Expected Output

//SG201AB

//345-ASDTG

ABC //123123

RRR //5690AB

//5089--ASD

flying008

Hi, @BRRLL99

The output of line 3 are you sure it's not //123123 but ABC //123123? and there's no SAR here.

BRRLL99

SAR will be in separate column
when there is SAR

it should pick entire ABC //123123 { before text// till the next space}

for others it should be only //123123

caltang

Can you give a longer list of sample data @BRRLL99 ? Maybe give us an excel list so we can see and make it dynamic...?

BRRLL99

D_1	data
GBP	456 //SG201AB TGHFG01
INR	ABCF //345-ASDTG
SDF	001 //123123
SAR	PR4501 //5690AB 90111
SAR	R001AB //5089--ASD JKLP
USD	GHF // ABC001

Expected output:

data

//SG201AB

//345-ASDTG

//123123

PR4501 //5690AB

R001AB //5089--ASD

// ABC001

flying008

Hi, @BRRLL99

FYI.

use the formula :

REGEX_Replace([data], '^(\S+?)\s+(\/\/\s?[[:alnum:]\-]+?)(?=\s|$).*', IIF([D_1] = 'SAR', '$1 $2', '$2'))

录制_2024_05_20_13_52_38_572.gif

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703