Back to Contents Previous Next
Examples of use
Here are a few things that can be done with !CSvamp which might help to make things clearer.
i) Produce a ‘live’ list of email addresses for an HTML page.
The source CSV/TSV file had three fields:
Surname/First Name/email address
The output file had only 1 field, of the form (one continuous line):
“<li>[Surname]+”, “+[First Name] + ”, <A HREF=“mailto:”+ [email address]+“”>“+[email address]+”</A><BR>“
The resulting output-file, when copied directly to an HTML page, produced a list of ‘live’ email addresses i.e. a double-click on the email address on the HTML page automatically opened a ‘compose email’ window.
ii) Extract a list of names plus telephone numbers from an address file.
The source address CSV/TSV file had 14 fields per record and these were:
Title/Initials/First Name/Partner’s First Name/Surname/Address Line #1/Address Line #2/Address Line #3/Address Line #4/Address Line #5/Address Line #6/Post Code/Telephone Number/email address
The output file had only 1 field: constructed as:
[First Name]+“ ”+[Surname]+“ Tel: ”+[Telephone Number]
iii) From the same source file as above, compile a new CSV/TSV file suitable for Xmas card addressing, with 8 fields as follows:
[First Name]+“ & ”+[Partner’s First Name]+“ ”+ [Surname] [Address Line #1] [Address Line #2] [Address Line #3] [Address Line #4] [Address Line #5] [Address Line #6] [Post Code]
iv) Extract specific records from an existing file.
Simply loaded the file and clicked on all of the Orange icons in turn, starting at the top i.e. to produce an output identical to the input.
Then selected/de-selected specific records, as required, before saving a new file.
v) Separate a sequence number from a list of files.
A list of photo-files was a single-field list of the form:
$.Photos.Holidays.Sept_2006.Picxxx/jpg
where xxx is a number, but not necessarily a fixed number of digits.
The requirement was to ‘copy’ the xxx into a new first field.
The sequence of actions was:
- split at trailing non-digit characters, to get a comma-separated 2-field list of the form
$.Photos.Holidays.Sept_2006.Picxxx,/jpg
- split the first field at trailing number, to get a comma-separated 3-field list of the form
$.Photos.Holidays.Sept_2006.Pic,xxx,/jpg
- in the main window, select only 2nd and 1st fields (in that order) and re-join fields 2 & 3 to existing 1st field - to get a comma-separated 2-field list of the form
xxx,$.Photos.Holidays.Sept_2006.Picxxx/jpg
Top of page Back to Contents Previous Next