Find and replace in text file

[Jon12345]

I have a couple of things I need to do to a csv file.

1. Find and Replace a particular couple of characters.

2. Remove the first column of data.

Any suggestions on the best way?

Thanks,

Jon

[JMichaelTX]

@Jon12345

Find and Replace a particular couple of characters.

1. Read the file into a KM variable
2. Use the KM "Search and Replace Variable" Action

See:
action:Read a File [Keyboard Maestro Wiki]
action:Search and Replace Variable [Keyboard Maestro Wiki]

@Jon12345

Remove the first column of data.

Use the KM "Search and Replace Variable" Action using Match (Regex) and replace with nothing
See: Regular Expressions [Keyboard Maestro Wiki]