Simple Find & Replace

[GELIEZ100]

Hi,

I’m using a simple Excel File to feed my F&R params to Alteryx some appear to be skipped.

E.g.

Find	Replace With
AD DRESS: EMAIL:	BOE:
ADDRE SS	BOE:
BO EMAIL:	BOE:
EM AIL	BOE:
EMAIL ADDRE SS:	BOE:
EMAIL ADDRES S:	BOE:
EMAIL ADDRES:	BOE:
EMAIL ADDRESS:	BOE:
EMAIL EMAIL	BOE:
EMAILADDRESS	BOE:
ADDRESS: BOE:	BOE:
ADDRESS,BOE:	BOE:
EMAIL  ADDRESS:	BOE:
EMAIL ADDRESS	BOE:
EMAIL:	BOE:

The 2 in red are being ignore!

[alexnajm]

This looks correct - have you selected the correct column to look in? You are looking with field “Blob” which doesn’t seem right to me, it should be a column with the text you are looking to replace

[GELIEZ100]

Thnx for coming back quickly :-)

Blob column is correct. Blob contains e.g. SAF | eMail: xxxxxxxx | Address: 1 Lincoln Place | Tel: 0123 456 1234 | Bill: $5.000

So, many rows exist. Trying to stadardise data because some rows say eMail. Others say eMa il etc. So, just cleaning Blob before splitting data using the pipe....

[GELIEZ100]

I'll prep a sample file to upload

[GratefulSkater]

Ah got it — sounds like a smart move to clean it up first. Normalizing those little differences (like “eMail” vs “eMa il”) will save you a ton of headaches later when parsing. Once it’s standardized, splitting by the pipe should work perfectly. OneBloodRewards