Convert the field to another form using trim

sriniprad08

Hi Team,

I have a column with below values.

Input : 000-24.00000.001-S

output : 000-24.00000.S

Input : 000-24.00000.001-P

output : 000-24.00000.P

please let me know how to go about it,

Thanks,

Sri

Expression

Data Investigation

Accepted answers

alexnajm

Yes it is - see attached

Regex_Replace([Input], "(\d{3})-(\d{2}\.\d{5}\.)\d{3}-(\w)", "$1.$2$3")

Convert the field to another form using trim.yxmd

All comments

alexnajm

Regex_Replace([Input], "(\d{3}-\d{2}\.\d{5}\.)\d{3}-(\w)", "$1$2")

Convert the field to another form using trim.yxmd

binu_acs

@sriniprad08 again regex

REGEX_Replace([Input], '(.*)\..*\-(.*)', '$1.$2')

sriniprad08

thank you @alexnajm Perfect. is it possible to replace one of the "-" with "." like in Output 2

Input : 000-24.00000.001-S

output 1 : 000-24.00000.S

output 2 : 000.24.00000.S

Input : 000-24.00000.001-P

output 1 : 000-24.00000.P

output 1 : 000.24.00000.P

thanks

sriniprad08

thanks @binu_acs is it possible to do replace - with . in output 2 please?

Input : 000-24.00000.001-S

output 1 : 000-24.00000.S

output 2 : 000.24.00000.S

Input : 000-24.00000.001-P

output 1 : 000-24.00000.P

output 1 : 000.24.00000.P

thanks

alexnajm

Yes it is - see attached

Regex_Replace([Input], "(\d{3})-(\d{2}\.\d{5}\.)\d{3}-(\w)", "$1.$2$3")

Convert the field to another form using trim.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167