Tags » Delimiter

Change Column Separator on CSV in OpenOffice Calc

If you want to change the existing column separator or the “delimiter” of a CSV in open office, follow the easy steps :

Windows General

Combining & Splitting Text

Knowing how to combine two columns into one and vice versa quickly is so helpful.  I remember having to do this so many times and I thought surely there is a quicker way! 273 more words

Tips

To compare two cells in a single sheet

=IF(Sheet1!A1=Sheet2!A1,”true”,”false”)

To compare two cells in multiple sheets

=IF(A1=A2,”true”,”false”)

To Select a single row in excel

Shortcut Key: Shift + End + <Down Arrow> 41 more words

Excel Tips

What is the syntax to join a sequence, separated by a string?

<string name>.join(<sequence>)
#examples
str = "-"
str2 = "! "
str3 = ""
seq1 = ("1","2","3")
seq2 = ('Ursula', 'Yves','Pedro', 'Bernice')

print(str.join(seq1))
print(str2.join(seq2))
print(str3.join(seq2))

#output
1-2-3
Ursula! 6 more words

Convert Tab delimited strings

I had an issue to process a csv file with TAB delimited text lines. The existing code expected text lines with ; as delimiter.

Character TAB has ASCII Code 9. 150 more words

Nav 2013