We're taking some data out of a SQL database, and it's stored as RTF. What's the best way to convert this to plain text (keeping line breaks) using Excel? Using Power Query or something?
Looks like this (3 cells as example)
{\rtf1\ansi\ansicpg1252\deff0\deflang5129{\fonttbl{\f0\fnil\fcharset0 Tahoma;}}
{\colortbl ;\red0\green0\blue0;}
\viewkind4\uc1\pard\tx30\tx45\tx30\tx75\tx105\cf1\lang1033\f0\fs22 ASD repair\par
watch detecting asympt ATach most likely\par
not heart block\cf0\lang5129\fs23\par
}
{\rtf1\ansi\ansicpg1252\deff0\deflang5129{\fonttbl{\f0\fnil\fcharset0 Tahoma;}}
{\colortbl ;\red0\green0\blue0;}
\viewkind4\uc1\pard\tx30\tx45\tx30\tx75\tx105\cf1\lang1033\f0\fs22 I am certain these are pseudoseizures, but should exclude other path\par
echo ?structurally N heart\cf0\lang5129\fs23\par
}
{\rtf1\ansi\ansicpg1252\deff0\deflang5129{\fonttbl{\f0\fnil\fcharset0 Tahoma;}}
{\colortbl ;\red0\green0\blue0;}
\viewkind4\uc1\pard\tx30\tx45\tx30\tx75\tx105\cf1\lang1033\f0\fs22 frequent but minimally symtomatic RVOT VT\par
imaging N\par
recommend no Rx\cf0\lang5129\fs23\par
}
