Excel : Join strings from two cells

To concatenate two cells to one cell and have them in two different line use the below technique.

Lets say A1 has This is line one
B1 has This is line two

To have C1 as This is line one This is line two give =CONCATENATE(A1," ",B1)

To have C1 as This is line one
This is line two
give =A1&CHAR(10)&B1

Comments

Pokemon Go download link

Pokemon go has become the buzz word in tech industry now. Nintendo, the Japanese video game company are the creates of this game. Its first of it kind to integrate a game with augmented reality , so people has to go out to real world with there android or iPhone to catch em all . You can download Pokemon go from this link.

Primitive datatypes in hive

String data types STRING VARCHAR CHAR TINYINT SMALLINT INT BIGINT FLOAT DOUBLE DECIMAL BOOLEAN TIMESTAMP DATE

UNIX : How to ignore lines with certain names

Sometimes we need to ignore multiple lines with certain words and get the list out of the file. usually it will be a log file to read . The below grep command can be used to ignore multiple words present in a text file. Lets say the file contain $ cat list.txt apple orange apple banana papaya Now we need to ignore line with orange , banana and papaya . So we can use the below grep command. $ cat list.txt | grep -Ev "orange|banana|papaya" apple apple It will ignore lines with the words in -v part of grep.

Tech Info Talks

Search This Blog