Simple Find & Replace

Question

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!

GELIEZ100 · Answer

I'll prep a sample file to upload

GELIEZ100 · Answer

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....

alexnajm · Answer

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